create table customer(cno number(15) primary key,
cname varchar2(20),
cid varchar2(20),
password varchar2(20),
rpassword varchar2(20),
street varchar2(20),
city varchar2(20),
state varchar2(20),
country varchar2(20),
pincode number(10),
phone number(10),
fax number(10),
email varchar2(20),
crno number(20),
crtype varchar2(20),
expdate varchar2(20));



create table path(
vid varchar2(20),
source varchar2(20),
destination varchar2(20),
dum1 number(2),
dum2 number(2),
vsday number(2));


create table vehicle(
vid varchar2(20)primary key,
vname varchar2(20),
tvolume number(4),
cpunit number(8));




create table booking(
cno number(10),
vid varchar2(10),
source number(2),
destination number(2),
bday number(2),
bmonth number(2),
byear number(4),
bvolume number(6));



create table gdet( 
cno number(10),
vid varchar2(20),
ino number(2),
iname varchar2(20),
il number(2),
ib number(2),
ih number(2),
cc number(6),
iv number(6),
packid number(5));


create table myreceiver(cno number(10) primary key,
rname varchar2(20),
street varchar2(20),
city varchar2(20),
state varchar2(20),
country varchar2(20),
pincode number(10),
fax number(10),
phone number(10),
email varchar2(20));


create table check_point_info(vid varchar2(20),
checkpoint varchar2(20),
checkdate varchar2(15),
checktime varchar2(10));

create table login_check(cid varchar2(20) primary key,
password varchar2(20),
role varchar2(10));



create table bill_det(packid number(6) primary key,
bookdate varchar2(20),
source varchar2(20),
destination varchar2(20),
tvol number(7),
tamount number(10));